﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data.SqlClient;
using System.Data;

namespace ankietyzacja.Dao
{
    public class TrybStudiowDao : Dao
    {


        public TrybStudiowDao(SqlConnection c, SqlTransaction t)
            : base(c, t)
        {
        }





        public DataTable loadForTryb(String trybStudiow)
        {

            String sql =
        @" SELECT *
             FROM TRYBSTUDIOW
     WHERE lower(TRYBSTUDIOW) = lower(@TRYBSTUDIOW);
     ";
            SqlCommand command = new SqlCommand(sql, connection, transaction);
            command.Parameters.Add(new SqlParameter("@TRYBSTUDIOW", trybStudiow));


            DataTable dataTable = new DataTable();

            new SqlDataAdapter(command).Fill(dataTable);

            return dataTable;

        }


      


        
    }


}